<?php

namespace app\admin\controller;

class Word extends Base
{
    //列表
    public function lists()
    {
        if (is_post()) {
            $d = $this->post;
            $map = [];
            if ($d['keyword']) $map[] = ['and', 'title|uuid', 'like', "%{$d['keyword']}%"];
            if ($d['min_time'] != '') $map[] = ['and', 'create_time', '>=', strtotime($d['min_time'])];
            if ($d['max_time'] != '') $map[] = ['and', 'create_time', '<=', strtotime($d['max_time'])];
            $w = where($map);
            $rs = $this->db->query("select *  from word  $w[0] order by sort desc,id desc" . limit($d['page'], $d['limit']), $w[1], '', true);
            if ($rs) {
                $rule = [
                    'create_time' => 'com_time_format',
                ];
                $data = com_format($rs[0], $rule);
                suc($data, $rs[1]);
            } else {
                suc([], 0);
            }
            $this->fetch();
        }
        return $this->fetch();
    }

    //添加
    public function add()
    {
        if (is_post()) {
            $d = $this->post;
            $rule = [
                'title'=>'require',
                'uuid'=>"require|unique:word,uuid",
            ];
            $msg = [];
            check($rule,$msg,$d);
            $d['create_time'] = time();
            if ($d['content'] != '') $d['content'] = htmlspecialchars_decode($d['content']);
            $id = $this->db->insert('word', $d);
            if ($id) {
                cookie('js_msg', '添加成功');
                cookie('js_function', 'preload');
                return suc();
            } else {
                err('添加失败');
            }
        }
        return $this->fetch();
    }

    //编辑
    public function edit()
    {
        if (is_post()) {
            $d = $this->post;
            $rule = [
                'id'=>'require',
                'title'=>'require',
                'uuid'=>"require|unique:word,uuid,{$d['id']}",
            ];
            $msg = [];
            check($rule,$msg,$d);
            $d['update_time'] = time();
            if ($d['content'] != '') $d['content'] = htmlspecialchars_decode($d['content']);
            $id = $this->db->update('word', $d);
            if ($id) {
                cookie('js_msg', '修改成功');
                cookie('js_function', 'preload');
                return suc();
            } else {
                err('修改失败');
            }
        }
        $id = $this->get['id'];
        $info = $this->db->query("select * from word where id=?", [$id], 1);
        return $this->fetch(['info' => $info]);
    }

    //删除
    public function del()
    {
        if (is_post()) {
            $d = $this->post;
            $this->db->delete('word', $d['id']);
            cookie('js_msg', '删除成功');
            cookie('js_function', 'close|reload');
            return suc();
        }
    }

    #批量删除
    function delall()
    {
        if (is_post()) {
            $d = $this->post;
            $ids = $d['id'];
            foreach ($ids as $id) {
                $this->db->delete('word', $id);
            }
            cookie('js_msg', '删除成功');
            cookie('js_function', 'close|reload');
            return suc();
        }
    }

    //详情
    public function detail($id)
    {
        return $this->fetch();
    }
}
